[dbo].[asi_ScheduledTaskHistoryAppendLog]

SQLServer > iMIS1521GA > Stored Procedures > dbo.asi_ScheduledTaskHistoryAppendLog

Property	Value
ANSI Nulls On
Quoted Identifier On

Name	Data Type	Max Length (Bytes)
@key	uniqueidentifier	16
@textToAppend	nvarchar(4000)	8000

CREATE  proc [dbo].[asi_ScheduledTaskHistoryAppendLog]
@key uniqueidentifier,
@textToAppend nvarchar(4000) as

DECLARE @ptr varbinary(16)

SELECT  @ptr = TEXTPTR(LogText)
FROM   ScheduledTaskHistory
WHERE  ScheduledTaskHistoryKey = @key
IF TEXTVALID('ScheduledTaskHistory.LogText', @ptr) = 1
BEGIN
   UPDATETEXT ScheduledTaskHistory.LogText @ptr NULL 0 @textToAppend --Append to end
   --UPDATETEXT ScheduledTaskHistory.LogText @ptr 0 0 @textToAppend --Insert at beginning
END
ELSE
BEGIN
   UPDATE ScheduledTaskHistory
      SET LogText = @textToAppend
    WHERE ScheduledTaskHistoryKey = @key
END

GO